Checks and Controls in Spreadsheets
نویسنده
چکیده
Spreadsheets that are informally created are harder to test than they should be. Simple cross-foot checks or being easily readable are modest but attainable goals for every spreadsheet developer. This paper lists some tips on building self-checking into a spreadsheet in order to provide more confidence to the reader that a spreadsheet is robust.
منابع مشابه
Self-Checks In Spreadsheets: A Survey Of Current Practice
A common application of spreadsheets is the development of models that deliver projections of the future financial statements of companies established to pursue ventures that are subject to project financing. A survey of 11 such spreadsheets prepared by a range of organisations shows that the amount of self-testing included in such models ranges between one formula of testing for each three for...
متن کاملLeveraging User Profile and Behaviour to Design Practical Spreadsheet Controls for the Finance Function
Recognizing that the use of spreadsheets within finance will likely not subside in the near future, this paper discusses a major barrier that is preventing more organizations from adopting enterprise spreadsheet management programs. But even without a corporate mandated effort to improve spreadsheet controls, finance functions can still take simple yet effective steps to start managing the risk...
متن کاملControls over Spreadsheets for Financial Reporting in Practice
Past studies show that only a small percent of organizations implement and enforce formal rules or informal guidelines for the designing, testing, documenting, using, modifying, sharing and archiving of spreadsheet models. Due to lack of such policies, there has been little research on how companies can effectively govern spreadsheets throughout their life cycle. This paper describes a survey i...
متن کاملManaging Critical Spreadsheets in a Compliant Environment
The use of uncontrolled financial spreadsheets can expose organizations to unacceptable business and compliance risks, including errors in the financial reporting process, spreadsheet misuse and fraud, or even significant operational errors. These errors have been well documented and thoroughly researched by the European Spreadsheet Risks Interest Group [EuSpRIG, 2005]. With the advent of regul...
متن کاملAutomating Spreadsheet Discovery & Risk Assessment
There have been many articles and mishaps published about the risks of uncontrolled spreadsheets in today’s business environment, including non-compliance, operational risk, errors, and fraud all leading to significant loss events. Spreadsheets fall into the realm of end user developed applications and are often absent the proper safeguards and controls an IT organization would enforce for ente...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- CoRR
دوره abs/0908.1186 شماره
صفحات -
تاریخ انتشار 2009